﻿CREATE TABLE [dbo].[tblInventoryTransactionHistory] (
    [InventoryTransactionHistoryID]       INT           IDENTITY (1, 1) NOT NULL,
    [InventoryTransactionID]              INT           NOT NULL,
    [PriorInventoryTransactionStatusCode] CHAR (1)      NULL,
    [NewInventoryTransactionStatusCode]   CHAR (1)      NOT NULL,
    [CreateDate]                          SMALLDATETIME NOT NULL,
    [AgentID]                             INT           NULL
);

